[ROOT]  dt  DimEmployee  <  WHERE ParentEmployeeId EQ '142'  >   

7 items

DimEmployeeId	BaseRate	BirthDate	Department	EmailAddress	EmergencyContactName	EmergencyContactPhone	EmployeeNationalIDAlternateKey	FirstName	Gender	HireDate	LastName	LoginID	MaritalStatus	MiddleName	ParentEmployeeId	PayFrequency	Phone	Photo	SalariedFlag	SickLeaveHours	StartDate	Status	Title	VacationHours
96	19	1985-12-26	Finance	candy0@adventure-works.com	Candy Spoon	920-555-0177	60517918	Candy	F	2018-11-09	Spoon	adventure-works\candy0	S	L	142	2	920-555-0177			50	2018-11-09	Current	Accounts Receivable Specialist	61
61	19	1986-01-07	Finance	deborah0@adventure-works.com	Deborah Poe	602-555-0194	363923697	Deborah	F	2018-10-21	Poe	adventure-works\deborah0	M	E	142	2	602-555-0194			50	2018-10-21	Current	Accounts Receivable Specialist	60
133	19	1994-07-24	Finance	bryan1@adventure-works.com	Bryan Walton	935-555-0199	931190412	Bryan	M	2018-11-27	Walton	adventure-works\bryan1	S	A	142	2	935-555-0199			51	2018-11-27	Current	Accounts Receivable Specialist	62
170	19	1986-12-18	Finance	dragan0@adventure-works.com	Dragan Tomic	117-555-0185	663843431	Dragan	M	2018-12-15	Tomic	adventure-works\dragan0	M	K	142	2	117-555-0185			51	2018-12-15	Current	Accounts Payable Specialist	63
182	26.4423	1985-11-06	Finance	barbara1@adventure-works.com	Barbara Moreland	822-555-0145	363910111	Barbara	F	2018-12-22	Moreland	adventure-works\barbara1	M	C	142	2	822-555-0145		1	49	2018-12-22	Current	Accountant	58
205	19	1989-01-09	Finance	janet0@adventure-works.com	Janet Sheperdigian	393-555-0186	519756660	Janet	F	2019-01-02	Sheperdigian	adventure-works\janet0	M	L	142	2	393-555-0186			52	2019-01-02	Current	Accounts Payable Specialist	64
220	26.4423	1989-05-03	Finance	mike0@adventure-works.com	Mike Seamans	927-555-0150	480951955	Mike	M	2019-01-09	Seamans	adventure-works\mike0	S	K	142	2	927-555-0150		1	49	2019-01-09	Current	Accountant	59

Generated 2024-05-02 20:57:57.266 UTC